﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization;

namespace Model
{
    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("OrderInfo", "OrderInfo", new string[] { "SHEETID" })]
    [KnownType(typeof(OrderInfo))]
    public class OrderInfo //: MB.Orm.Common.BaseModel
    {
        public OrderInfo()
        {

        }
        private String _SHEETID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SHEETID", System.Data.DbType.String)]
        public String SHEETID { get { return _SHEETID; } set { _SHEETID = value; } }
        private int _EDITSHOPID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITSHOPID", System.Data.DbType.Int32)]
        public int EDITSHOPID { get { return _EDITSHOPID; } set { _EDITSHOPID = value; } }
        private String _REFSHEETID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REFSHEETID", System.Data.DbType.String)]
        public String REFSHEETID { get { return _REFSHEETID; } set { _REFSHEETID = value; } }
        private int _REFSHEETTYPE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REFSHEETTYPE", System.Data.DbType.Int32)]
        public int REFSHEETTYPE { get { return _REFSHEETTYPE; } set { _REFSHEETTYPE = value; } }
        private int _SALESHOPID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SALESHOPID", System.Data.DbType.Int32)]
        public int SALESHOPID { get { return _SALESHOPID; } set { _SALESHOPID = value; } }
        private int _OUTSHOPID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OUTSHOPID", System.Data.DbType.Int32)]
        public int OUTSHOPID { get { return _OUTSHOPID; } set { _OUTSHOPID = value; } }
        private int _CUSTOMERID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CUSTOMERID", System.Data.DbType.Int32)]
        public int CUSTOMERID { get { return _CUSTOMERID; } set { _CUSTOMERID = value; } }
        private String _CUSTOMERREMARK1;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CUSTOMERREMARK1", System.Data.DbType.String)]
        public String CUSTOMERREMARK1 { get { return _CUSTOMERREMARK1; } set { _CUSTOMERREMARK1 = value; } }
        private String _CUSTOMERREMARK2;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CUSTOMERREMARK2", System.Data.DbType.String)]
        public String CUSTOMERREMARK2 { get { return _CUSTOMERREMARK2; } set { _CUSTOMERREMARK2 = value; } }
        private String _CUSTOMERREMARK3;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CUSTOMERREMARK3", System.Data.DbType.String)]
        public String CUSTOMERREMARK3 { get { return _CUSTOMERREMARK3; } set { _CUSTOMERREMARK3 = value; } }
        private int _MEMBERID;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("MEMBERID", System.Data.DbType.Int32)]
        public int MEMBERID { get { return _MEMBERID; } set { _MEMBERID = value; } }
        private int _SALEORDERFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SALEORDERFLAG", System.Data.DbType.Int32)]
        public int SALEORDERFLAG { get { return _SALEORDERFLAG; } set { _SALEORDERFLAG = value; } }
        private String _RATIONDATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("RATIONDATE", System.Data.DbType.String)]
        public string RATIONDATE { get { return _RATIONDATE; } set { _RATIONDATE = value; } }
        private int _RATIONTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("RATIONTIME", System.Data.DbType.Int32)]
        public int RATIONTIME { get { return _RATIONTIME; } set { _RATIONTIME = value; } }
        private int _CUSTOMERPAYTYPE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CUSTOMERPAYTYPE", System.Data.DbType.Int32)]
        public int CUSTOMERPAYTYPE { get { return _CUSTOMERPAYTYPE; } set { _CUSTOMERPAYTYPE = value; } }
        private int _PAYFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PAYFLAG", System.Data.DbType.Int32)]
        public int PAYFLAG { get { return _PAYFLAG; } set { _PAYFLAG = value; } }
        private int _DELIVERYMODE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DELIVERYMODE", System.Data.DbType.Int32)]
        public int DELIVERYMODE { get { return _DELIVERYMODE; } set { _DELIVERYMODE = value; } }
        private int _CHECKRATIONFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKRATIONFLAG", System.Data.DbType.Int32)]
        public int CHECKRATIONFLAG { get { return _CHECKRATIONFLAG; } set { _CHECKRATIONFLAG = value; } }
        private DateTime _ORDERTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERTIME", System.Data.DbType.DateTime)]
        public DateTime ORDERTIME { get { return _ORDERTIME; } set { _ORDERTIME = value; } }
        private DateTime _PAYTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PAYTIME", System.Data.DbType.DateTime)]
        public DateTime PAYTIME { get { return _PAYTIME; } set { _PAYTIME = value; } }
        private DateTime _SHIPMENTSTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SHIPMENTSTIME", System.Data.DbType.DateTime)]
        public DateTime SHIPMENTSTIME { get { return _SHIPMENTSTIME; } set { _SHIPMENTSTIME = value; } }
        private int _PROBLEMFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PROBLEMFLAG", System.Data.DbType.Int32)]
        public int PROBLEMFLAG { get { return _PROBLEMFLAG; } set { _PROBLEMFLAG = value; } }
        private String _PROBLEMREAMRK;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PROBLEMREAMRK", System.Data.DbType.String)]
        public String PROBLEMREAMRK { get { return _PROBLEMREAMRK; } set { _PROBLEMREAMRK = value; } }
        private int _INVOICETYPE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("INVOICETYPE", System.Data.DbType.Int32)]
        public int INVOICETYPE { get { return _INVOICETYPE; } set { _INVOICETYPE = value; } }
        private String _INVOICEHEAD;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("INVOICEHEAD", System.Data.DbType.String)]
        public String INVOICEHEAD { get { return _INVOICEHEAD; } set { _INVOICEHEAD = value; } }
        private String _INVOICECONTENT;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("INVOICECONTENT", System.Data.DbType.String)]
        public String INVOICECONTENT { get { return _INVOICECONTENT; } set { _INVOICECONTENT = value; } }
        private String _CONSIGNEE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CONSIGNEE", System.Data.DbType.String)]
        public String CONSIGNEE { get { return _CONSIGNEE; } set { _CONSIGNEE = value; } }
        private String _CONSIGNEEADD;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CONSIGNEEADD", System.Data.DbType.String)]
        public String CONSIGNEEADD { get { return _CONSIGNEEADD; } set { _CONSIGNEEADD = value; } }
        private String _POSTCODE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("POSTCODE", System.Data.DbType.String)]
        public String POSTCODE { get { return _POSTCODE; } set { _POSTCODE = value; } }
        private String _TEL;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TEL", System.Data.DbType.String)]
        public String TEL { get { return _TEL; } set { _TEL = value; } }
        private String _MOBILE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("MOBILE", System.Data.DbType.String)]
        public String MOBILE { get { return _MOBILE; } set { _MOBILE = value; } }
        private String _LANDMARKS;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("LANDMARKS", System.Data.DbType.String)]
        public String LANDMARKS { get { return _LANDMARKS; } set { _LANDMARKS = value; } }
        private String _EMAIL;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EMAIL", System.Data.DbType.String)]
        public String EMAIL { get { return _EMAIL; } set { _EMAIL = value; } }
        private int _PACKFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PACKFLAG", System.Data.DbType.Int32)]
        public int PACKFLAG { get { return _PACKFLAG; } set { _PACKFLAG = value; } }
        private String _SHIPPER;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SHIPPER", System.Data.DbType.String)]
        public String SHIPPER { get { return _SHIPPER; } set { _SHIPPER = value; } }
        private String _SHIPMOBILE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SHIPMOBILE", System.Data.DbType.String)]
        public String SHIPMOBILE { get { return _SHIPMOBILE; } set { _SHIPMOBILE = value; } }
        private String _SHIPORDERNO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("SHIPORDERNO", System.Data.DbType.String)]
        public String SHIPORDERNO { get { return _SHIPORDERNO; } set { _SHIPORDERNO = value; } }
        private int _GREETINGFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GREETINGFLAG", System.Data.DbType.Int32)]
        public int GREETINGFLAG { get { return _GREETINGFLAG; } set { _GREETINGFLAG = value; } }
        private String _GREETINGCONTENT;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("GREETINGCONTENT", System.Data.DbType.String)]
        public String GREETINGCONTENT { get { return _GREETINGCONTENT; } set { _GREETINGCONTENT = value; } }
        private int _AFTERSERVICEFLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AFTERSERVICEFLAG", System.Data.DbType.Int32)]
        public int AFTERSERVICEFLAG { get { return _AFTERSERVICEFLAG; } set { _AFTERSERVICEFLAG = value; } }
        private String _AFTERSERVICEREAMRK;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AFTERSERVICEREAMRK", System.Data.DbType.String)]
        public String AFTERSERVICEREAMRK { get { return _AFTERSERVICEREAMRK; } set { _AFTERSERVICEREAMRK = value; } }
        private int _ORDERSOURCETYPE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERSOURCETYPE", System.Data.DbType.Int32)]
        public int ORDERSOURCETYPE { get { return _ORDERSOURCETYPE; } set { _ORDERSOURCETYPE = value; } }
        private Decimal _TOTALQTY;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALQTY", System.Data.DbType.Decimal)]
        public Decimal TOTALQTY { get { return _TOTALQTY; } set { _TOTALQTY = value; } }
        private Decimal _TOTALCOSTTAXVALUE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALCOSTTAXVALUE", System.Data.DbType.Decimal)]
        public Decimal TOTALCOSTTAXVALUE { get { return _TOTALCOSTTAXVALUE; } set { _TOTALCOSTTAXVALUE = value; } }
        private Decimal _TOTALCOSTVALUE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALCOSTVALUE", System.Data.DbType.Decimal)]
        public Decimal TOTALCOSTVALUE { get { return _TOTALCOSTVALUE; } set { _TOTALCOSTVALUE = value; } }
        private Decimal _TOTALSALETAXVALUE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALSALETAXVALUE", System.Data.DbType.Decimal)]
        public Decimal TOTALSALETAXVALUE { get { return _TOTALSALETAXVALUE; } set { _TOTALSALETAXVALUE = value; } }
        private Decimal _TOTALSALEVALUE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALSALEVALUE", System.Data.DbType.Decimal)]
        public Decimal TOTALSALEVALUE { get { return _TOTALSALEVALUE; } set { _TOTALSALEVALUE = value; } }
        private Decimal _TOTALDISCVALUE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("TOTALDISCVALUE", System.Data.DbType.Decimal)]
        public Decimal TOTALDISCVALUE { get { return _TOTALDISCVALUE; } set { _TOTALDISCVALUE = value; } }
        private int _FLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FLAG", System.Data.DbType.Int32)]
        public int FLAG { get { return _FLAG; } set { _FLAG = value; } }
        private int _CHECKSTATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKSTATE", System.Data.DbType.Int32)]
        public int CHECKSTATE { get { return _CHECKSTATE; } set { _CHECKSTATE = value; } }
        private String _CHECKREMARK;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKREMARK", System.Data.DbType.String)]
        public String CHECKREMARK { get { return _CHECKREMARK; } set { _CHECKREMARK = value; } }
        private String _EDITOR;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITOR", System.Data.DbType.String)]
        public String EDITOR { get { return _EDITOR; } set { _EDITOR = value; } }
        private DateTime _EDITDATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITDATE", System.Data.DbType.DateTime)]
        public DateTime EDITDATE { get { return _EDITDATE; } set { _EDITDATE = value; } }
        private DateTime _EDITTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITTIME", System.Data.DbType.DateTime)]
        public DateTime EDITTIME { get { return _EDITTIME; } set { _EDITTIME = value; } }
        private String _AGENT1;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AGENT1", System.Data.DbType.String)]
        public String AGENT1 { get { return _AGENT1; } set { _AGENT1 = value; } }
        private String _AGENT2;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AGENT2", System.Data.DbType.String)]
        public String AGENT2 { get { return _AGENT2; } set { _AGENT2 = value; } }
        private String _AGENT3;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AGENT3", System.Data.DbType.String)]
        public String AGENT3 { get { return _AGENT3; } set { _AGENT3 = value; } }
        private String _NOTE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("NOTE", System.Data.DbType.String)]
        public String NOTE { get { return _NOTE; } set { _NOTE = value; } }
        private String _CHECKER;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKER", System.Data.DbType.String)]
        public String CHECKER { get { return _CHECKER; } set { _CHECKER = value; } }
        private DateTime _CHECKDATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKDATE", System.Data.DbType.DateTime)]
        public DateTime CHECKDATE { get { return _CHECKDATE; } set { _CHECKDATE = value; } }
        private DateTime _CHECKTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECKTIME", System.Data.DbType.DateTime)]
        public DateTime CHECKTIME { get { return _CHECKTIME; } set { _CHECKTIME = value; } }
        private int _PRINTCOUNT;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PRINTCOUNT", System.Data.DbType.Int32)]
        public int PRINTCOUNT { get { return _PRINTCOUNT; } set { _PRINTCOUNT = value; } }
        private String _APPORDERNO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("APPORDERNO", System.Data.DbType.String)]
        public String APPORDERNO { get { return _APPORDERNO; } set { _APPORDERNO = value; } }

        private List<OrderInfoDetail> _orderDetail;
        public List<OrderInfoDetail> orderDetail { get { return _orderDetail; } set { _orderDetail = value; } } 
    }
}
